[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

Predefined Function Definitions

The Syntax entry for each function defined in this clause corresponds to a call to that function. The names in any Syntax entry typeset as in number and string-1, are parameter names for that function, and are local to that function definition's description.

When the type of an argument passed to a function is incompatible with the type expected the error value #VALUE! is returned by that function.

The set of predefined functions is divided into the following functional categories:

 

Category

Formulas

Cube

CUBEKPIMEMBER (§3.17.7.65), CUBEMEMBER (§3.17.7.65), CUBEMEMBERPROPERTY (§3.17.7.66), CUBERANKEDMEMBER (§3.17.7.67), CUBESET (§3.17.7.68), CUBESETCOUNT (§3.17.7.69), CUBEVALUE (§3.17.7.70)

Database

DAVERAGE (§3.17.7.77), DCOUNT (§3.17.7.80), DCOUNTA (§3.17.7.81), DGET (§3.17.7.90), DMAX (§3.17.7.91), DMIN (§3.17.7.92), DPRODUCT (§3.17.7.96), DSTDEV (§3.17.7.97), DSTDEVP (§3.17.7.98), DSUM (§3.17.7.99), DVAR (§3.17.7.101), and DVARP (§3.17.7.102).

Date and Time

DATE (§3.17.7.73), DATEDIF (§3.17.7.75), DATEVALUE (§3.17.7.75), DAY (§3.17.7.77), DAYS360 (§3.17.7.79), EDATE (§3.17.7.103), EOMONTH (§3.17.7.105), HOUR (§3.17.7.142), MINUTE (§3.17.7.211), MONTH (§3.17.7.217), NETWORKDAYS (§3.17.7.223), NOW (§3.17.7.231), SECOND (§3.17.7.284), TIME (§3.17.7.320), TIMEVALUE (§3.17.7.321), TODAY (§3.17.7.322), WEEKDAY (§3.17.7.340), WEEKNUM (§3.17.7.342), WORKDAY (§3.17.7.343), YEAR (§3.17.7.346), and YEARFRAC (§3.17.7.348)

Engineering

BESSELI (§3.17.7.23), BESSELJ (§3.17.7.24), BESSELK (§3.17.7.25), BESSELY (§3.17.7.26), BIN2DEC (§3.17.7.29), BIN2HEX (§3.17.7.30), BIN2OCT (§3.17.7.31), COMPLEX (§3.17.7.45), CONVERT (§3.17.7.48), DEC2BIN (§3.17.7.83), DEC2HEX (§3.17.7.85), DEC2OCT (§3.17.7.86), DELTA (§3.17.7.88), ERF (§3.17.7.107), ERFC (§3.17.7.108), GESTEP (§3.17.7.135), HEX2BIN (§3.17.7.138), HEX2DEC (§3.17.7.140), HEX2OCT (§3.17.7.141), IMABS (§3.17.7.148), IMAGINARY (§3.17.7.149), IMARGUMENT (§3.17.7.150), IMCONJUGATE (§3.17.7.151), IMCOS (§3.17.7.152), IMDIV (§3.17.7.153), IMEXP (§3.17.7.154), IMLN (§3.17.7.155), IMLOG10 (§3.17.7.156), IMLOG2 (§3.17.7.157), IMPOWER (§3.17.7.158), IMPRODUCT (§3.17.7.159), IMREAL (§3.17.7.160), IMSIN (§3.17.7.161), IMSQRT (§3.17.7.162), IMSUB (§3.17.7.163), IMSUM (§3.17.7.164), OCT2BIN (§3.17.7.233), OCT2DEC (§3.17.7.235), and OCT2HEX (§3.17.7.236).

Financial

ACCRINT (§3.17.7.2), ACCRINTM (§3.17.7.2), AMORDEGRC (§3.17.7.7), AMORLINC (§3.17.7.7), COUPDAYBS (§3.17.7.58), COUPDAYS (§3.17.7.57), COUPDAYSNC (§3.17.7.59), COUPNCD (§3.17.7.59), COUPNUM (§3.17.7.60), COUPPCD (§3.17.7.61), CUMIPMT (§3.17.7.71), CUMPRINC (§3.17.7.72), DB (§3.17.7.80), DDB (§3.17.7.82), DISC (§3.17.7.90), DOLLARDE (§3.17.7.95), DOLLARFR (§3.17.7.95), DURATION (§3.17.7.100), EFFECT (§3.17.7.105), FV (§3.17.7.128), FVSCHEDULE (§3.17.7.128), INTRATE (§3.17.7.170), IPMT (§3.17.7.170), IRR (§3.17.7.171), ISPMT (§3.17.7.182), MDURATION (§3.17.7.206), MIRR (§3.17.7.214), NOMINAL (§3.17.7.225), NPER (§3.17.7.232), NPV (§3.17.7.232), ODDFPRICE (§3.17.7.206), ODDFYIELD (§3.17.7.238), ODDLPRICE (§3.17.7.239), ODDLYIELD (§3.17.7.240), PMT (§3.17.7.250), PPMT (§3.17.7.253), PRICE (§3.17.7.253), PRICEDISC (§3.17.7.254), PRICEMAT (§3.17.7.255), PV (§3.17.7.260), RATE (§3.17.7.266), RECEIVED (§3.17.7.267), SLN (§3.17.7.289), SYD (§3.17.7.311), TBILLEQ (§3.17.7.315), TBILLPRICE (§3.17.7.315), TBILLYIELD (§3.17.7.316), VDB (§3.17.7.338), XIRR (§3.17.7.345), XNPV (§3.17.7.345), YIELD (§3.17.7.349), YIELDDISC (§3.17.7.349), and YIELDMAT (§3.17.7.350).

Information

CELL (§3.17.7.34), ERROR.TYPE (§3.17.7.109), INFO (§3.17.7.167), ISBLANK (§3.17.7.172), ISERR (§3.17.7.174), ISERROR (§3.17.7.175), ISEVEN (§3.17.7.176), ISLOGICAL (§3.17.7.177), ISNA (§3.17.7.178), ISNONTEXT (§3.17.7.179), ISNUMBER (§3.17.7.180), ISODD (§3.17.7.181), ISREF (§3.17.7.182), ISTEXT (§3.17.7.184), N (§3.17.7.221), NA (§3.17.7.222), and TYPE (§3.17.7.330).

Logical

AND (§3.17.7.8), FALSE (§3.17.7.116), IF (§3.17.7.146), IFERROR (§3.17.7.147), NOT (§3.17.7.229), OR (§3.17.7.242), and TRUE (§3.17.7.327).

Lookup and Reference

ADDRESS (§3.17.7.6), AREAS (§3.17.7.10), CHOOSE (§3.17.7.39), COLUMN (§3.17.7.42), COLUMNS (§3.17.7.43, GETPIVOTDATA (§3.17.7.136), HLOOKUP (§3.17.7.142), HYPERLINK (§3.17.7.144), INDEX (§3.17.7.165), INDIRECT (§3.17.7.166), LOOKUP (§3.17.7.200), MATCH (§3.17.7.202), OFFSET (§3.17.7.241), ROW (§3.17.7.278), ROWS (§3.17.7.279), RTD (§3.17.7.280), TRANSPOSE (§3.17.7.324), and VLOOKUP (§3.17.7.339).

Math and Trig

ABS (§3.17.7.1), ACOS (§3.17.7.3), ACOSH (§3.17.7.5), ASIN (§3.17.7.12), ASINH (§3.17.7.13), ATAN (§3.17.7.14), ATAN2 (§3.17.7.15), ATANH (§3.17.7.16), CEILING (§3.17.7.33), COMBIN (§3.17.7.44), COS (§3.17.7.50), COSH (§3.17.7.51), DEGREES (§3.17.7.87), EVEN (§3.17.7.110), EXP (§3.17.7.112), FACT (§3.17.7.114), FACTDOUBLE (§3.17.7.115), FLOOR (§3.17.7.124), GCD (§3.17.7.133), INT (§3.17.7.168), LCM (§3.17.7.188), LN (§3.17.7.194), LOG (§3.17.7.195), LOG10 (§3.17.7.196), MDETERM (§3.17.7.205), MINVERSE (§3.17.7.213), MMULT (§3.17.7.214), MOD (§3.17.7.216), MROUND (§3.17.7.219), MULTINOMIAL (§3.17.7.220), ODD (§3.17.7.237), PI (§3.17.7.249), POWER (§3.17.7.251), PRODUCT (§3.17.7.257), QUOTIENT (§3.17.7.261), RADIANS (§3.17.7.263), RAND (§3.17.7.264), RANDBETWEEN (§3.17.7.265), ROMAN (§3.17.7.274), ROUND (§3.17.7.275), ROUNDDOWN (§3.17.7.276), ROUNDUP (§3.17.7.277), SERIESSUM (§3.17.7.285), SIGN (§3.17.7.286), SIN (§3.17.7.287), SINH (§3.17.7.288), SQRT (§3.17.7.293), SQRTPI (§3.17.7.294), SUBTOTAL (§3.17.7.302), SUM (§3.17.7.303), SUMIF (§3.17.7.304), SUMIFS (§3.17.7.305), SUMPRODUCT (§3.17.7.306), SUMSQ (§3.17.7.307), SUMX2MY2 (§3.17.7.308), SUMX2PY2 (§3.17.7.309), SUMXMY2 (§3.17.7.310), TAN (§3.17.7.313), TANH (§3.17.7.314), and TRUNC (§3.17.7.329).

Statistical

AVEDEV (§3.17.7.17), AVERAGE (§3.17.7.18), AVERAGEA (§3.17.7.19),AVERAGEIF (§3.17.7.20), AVERAGEIFS (§3.17.7.21), BETADIST (§3.17.7.27), BETAINV (§3.17.7.28), BINOMDIST (§3.17.7.32), CHIDIST (§3.17.7.36), CHIINV (§3.17.7.37), CHITEST (§3.17.7.38), CONFIDENCE (§3.17.7.47), CORREL (§3.17.7.49), COUNT (§3.17.7.52), COUNTA (§3.17.7.53), COUNTBLANK (§3.17.7.54), COUNTIF (§3.17.7.55),COUNTIFS (§3.17.7.56), COVAR (§3.17.7.62), CRITBINOM (§3.17.7.64), DEVSQ (§3.17.7.89), EXPONDIST (§3.17.7.113), FDIST (§3.17.7.117), FINV (§3.17.7.120), FISHER (§3.17.7.121), FISHERINV (§3.17.7.122), FORECAST (§3.17.7.125), FREQUENCY (§3.17.7.126), FTEST (§3.17.7.127), GAMMADIST (§3.17.7.129), GAMMAINV (§3.17.7.131), GAMMALN (§3.17.7.132), GEOMEAN (§3.17.7.134), GROWTH (§3.17.7.136), HARMEAN (§3.17.7.138), HYPGEOMDIST (§3.17.7.144), INTERCEPT (§3.17.7.169), KURT (§3.17.7.186), LARGE (§3.17.7.187), LINEST (§3.17.7.193), LOGEST (§3.17.7.197), LOGINV (§3.17.7.198), LOGNORMDIST (§3.17.7.199), MAX (§3.17.7.202), MAXA (§3.17.7.204), MEDIAN (§3.17.7.206), MIN (§3.17.7.210), MINA (§3.17.7.210), MODE (§3.17.7.217), NEGBINOMDIST (§3.17.7.223), NORMDIST (§3.17.7.225), NORMINV (§3.17.7.226), NORMSDIST (§3.17.7.227), NORMSINV (§3.17.7.228), PEARSON (§3.17.7.244), PERCENTILE (§3.17.7.244), PERCENTRANK (§3.17.7.245), PERMUT (§3.17.7.246), POISSON (§3.17.7.250), PROB (§3.17.7.256), QUARTILE (§3.17.7.260), RANK (§3.17.7.266), RSQ (§3.17.7.280), SKEW (§3.17.7.280), SLOPE (§3.17.7.290), SMALL (§3.17.7.291), STANDARDIZE (§3.17.7.295), STDEV (§3.17.7.295), STDEVA (§3.17.7.296), STDEVP (§3.17.7.297), STDEVPA (§3.17.7.298), STEYX (§3.17.7.299), TDIST (§3.17.7.317), TINV (§3.17.7.322), TREND (§3.17.7.324), TRIMMEAN (§3.17.7.327), TTEST (§3.17.7.330), VAR (§3.17.7.335), VARA (§3.17.7.335), VARP (§3.17.7.336), VARPA (§3.17.7.337), WEIBULL (§3.17.7.343), and ZTEST (§3.17.7.351).

Text and Data

ASC (§3.17.7.11), BAHTTEXT (§3.17.7.22), CHAR (§3.17.7.35), CLEAN (§3.17.7.40), CODE (§3.17.7.41), CONCATENATE (§3.17.7.46), DOLLAR (§3.17.7.93), EXACT (§3.17.7.111), FIND (§3.17.7.118), FINDB (§3.17.7.119), FIXED (§3.17.7.123), JIS (§3.17.7.185), LEFT (§3.17.7.189), LEFTB (§3.17.7.190), LEN (§3.17.7.191), LENB (§3.17.7.192), LOWER (§3.17.7.200), MID (§3.17.7.207), MIDB (§3.17.7.209), PHONETIC (§3.17.7.248), PROPER (§3.17.7.259), REPLACE (§3.17.7.269), REPLACEB (§3.17.7.270), REPT (§3.17.7.271), RIGHT (§3.17.7.272), RIGHTB (§3.17.7.273), SEARCH (§3.17.7.282), SEARCHB (§3.17.7.283), SUBSTITUTE (§3.17.7.300), T (§3.17.7.311), TEXT (§3.17.7.318), TRIM (§3.17.7.325), UPPER (§3.17.7.332), and VALUE (§3.17.7.334).